﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Ex_CTKT_05DataSet" targetNamespace="http://tempuri.org/Ex_CTKT_05DataSet.xsd" xmlns:mstns="http://tempuri.org/Ex_CTKT_05DataSet.xsd" xmlns="http://tempuri.org/Ex_CTKT_05DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Ex_CTKT_05ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Ex_CTKT_05ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.THUANVV.UI.Properties.Settings.GlobalReference.Default.Ex_CTKT_05ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CHINHANHTableAdapter" GeneratorDataComponentClassName="CHINHANHTableAdapter" Name="CHINHANH" UserDataComponentName="CHINHANHTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.CHINHANH" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CHINHANH] WHERE (([MaChiNhanh] = @Original_MaChiNhanh) AND ([TenChiNhanh] = @Original_TenChiNhanh) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ([MaCongTy] = @Original_MaCongTy))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CHINHANH] ([MaChiNhanh], [TenChiNhanh], [DienThoai], [MaCongTy]) VALUES (@MaChiNhanh, @TenChiNhanh, @DienThoai, @MaCongTy);
SELECT MaChiNhanh, TenChiNhanh, DienThoai, MaCongTy FROM CHINHANH WHERE (MaChiNhanh = @MaChiNhanh)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaChiNhanh, TenChiNhanh, DienThoai, MaCongTy FROM dbo.CHINHANH</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CHINHANH] SET [MaChiNhanh] = @MaChiNhanh, [TenChiNhanh] = @TenChiNhanh, [DienThoai] = @DienThoai, [MaCongTy] = @MaCongTy WHERE (([MaChiNhanh] = @Original_MaChiNhanh) AND ([TenChiNhanh] = @Original_TenChiNhanh) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ([MaCongTy] = @Original_MaCongTy));
SELECT MaChiNhanh, TenChiNhanh, DienThoai, MaCongTy FROM CHINHANH WHERE (MaChiNhanh = @MaChiNhanh)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaChiNhanh" DataSetColumn="MaChiNhanh" />
              <Mapping SourceColumn="TenChiNhanh" DataSetColumn="TenChiNhanh" />
              <Mapping SourceColumn="DienThoai" DataSetColumn="DienThoai" />
              <Mapping SourceColumn="MaCongTy" DataSetColumn="MaCongTy" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CONGTYTableAdapter" GeneratorDataComponentClassName="CONGTYTableAdapter" Name="CONGTY" UserDataComponentName="CONGTYTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.CONGTY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CONGTY] WHERE (([MaCongTy] = @Original_MaCongTy) AND ((@IsNull_TenCongTy = 1 AND [TenCongTy] IS NULL) OR ([TenCongTy] = @Original_TenCongTy)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenCongTy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CONGTY] ([MaCongTy], [TenCongTy], [DienThoai], [Website]) VALUES (@MaCongTy, @TenCongTy, @DienThoai, @Website);
SELECT MaCongTy, TenCongTy, DienThoai, Website FROM CONGTY WHERE (MaCongTy = @MaCongTy)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaCongTy, TenCongTy, DienThoai, Website FROM dbo.CONGTY</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CONGTY] SET [MaCongTy] = @MaCongTy, [TenCongTy] = @TenCongTy, [DienThoai] = @DienThoai, [Website] = @Website WHERE (([MaCongTy] = @Original_MaCongTy) AND ((@IsNull_TenCongTy = 1 AND [TenCongTy] IS NULL) OR ([TenCongTy] = @Original_TenCongTy)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_Website = 1 AND [Website] IS NULL) OR ([Website] = @Original_Website)));
SELECT MaCongTy, TenCongTy, DienThoai, Website FROM CONGTY WHERE (MaCongTy = @MaCongTy)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Website" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenCongTy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenCongTy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenCongTy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Website" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Website" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Website" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaCongTy" DataSetColumn="MaCongTy" />
              <Mapping SourceColumn="TenCongTy" DataSetColumn="TenCongTy" />
              <Mapping SourceColumn="DienThoai" DataSetColumn="DienThoai" />
              <Mapping SourceColumn="Website" DataSetColumn="Website" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DEANTableAdapter" GeneratorDataComponentClassName="DEANTableAdapter" Name="DEAN" UserDataComponentName="DEANTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.DEAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DEAN] WHERE (([MaDeAn] = @Original_MaDeAn) AND ([TenDeAn] = @Original_TenDeAn))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DEAN] ([MaDeAn], [TenDeAn]) VALUES (@MaDeAn, @TenDeAn);
SELECT MaDeAn, TenDeAn FROM DEAN WHERE (MaDeAn = @MaDeAn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaDeAn, TenDeAn FROM dbo.DEAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DEAN] SET [MaDeAn] = @MaDeAn, [TenDeAn] = @TenDeAn WHERE (([MaDeAn] = @Original_MaDeAn) AND ([TenDeAn] = @Original_TenDeAn));
SELECT MaDeAn, TenDeAn FROM DEAN WHERE (MaDeAn = @MaDeAn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaDeAn" DataSetColumn="MaDeAn" />
              <Mapping SourceColumn="TenDeAn" DataSetColumn="TenDeAn" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMKYNANGTableAdapter" GeneratorDataComponentClassName="DMKYNANGTableAdapter" Name="DMKYNANG" UserDataComponentName="DMKYNANGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.DMKYNANG" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMKYNANG] WHERE (([MaKyNang] = @Original_MaKyNang) AND ([TenKyNang] = @Original_TenKyNang) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMKYNANG] ([MaKyNang], [TenKyNang], [GhiChu]) VALUES (@MaKyNang, @TenKyNang, @GhiChu);
SELECT MaKyNang, TenKyNang, GhiChu FROM DMKYNANG WHERE (MaKyNang = @MaKyNang)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaKyNang, TenKyNang, GhiChu FROM dbo.DMKYNANG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMKYNANG] SET [MaKyNang] = @MaKyNang, [TenKyNang] = @TenKyNang, [GhiChu] = @GhiChu WHERE (([MaKyNang] = @Original_MaKyNang) AND ([TenKyNang] = @Original_TenKyNang) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)));
SELECT MaKyNang, TenKyNang, GhiChu FROM DMKYNANG WHERE (MaKyNang = @MaKyNang)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaKyNang" DataSetColumn="MaKyNang" />
              <Mapping SourceColumn="TenKyNang" DataSetColumn="TenKyNang" />
              <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMVITRITableAdapter" GeneratorDataComponentClassName="DMVITRITableAdapter" Name="DMVITRI" UserDataComponentName="DMVITRITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.DMVITRI" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMVITRI] WHERE (([MaViTri] = @Original_MaViTri) AND ([TenViTri] = @Original_TenViTri) AND ((@IsNull_TrangThai = 1 AND [TrangThai] IS NULL) OR ([TrangThai] = @Original_TrangThai)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMVITRI] ([MaViTri], [TenViTri], [TrangThai]) VALUES (@MaViTri, @TenViTri, @TrangThai);
SELECT MaViTri, TenViTri, TrangThai FROM DMVITRI WHERE (MaViTri = @MaViTri)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaViTri, TenViTri, TrangThai FROM dbo.DMVITRI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMVITRI] SET [MaViTri] = @MaViTri, [TenViTri] = @TenViTri, [TrangThai] = @TrangThai WHERE (([MaViTri] = @Original_MaViTri) AND ([TenViTri] = @Original_TenViTri) AND ((@IsNull_TrangThai = 1 AND [TrangThai] IS NULL) OR ([TrangThai] = @Original_TrangThai)));
SELECT MaViTri, TenViTri, TrangThai FROM DMVITRI WHERE (MaViTri = @MaViTri)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaViTri" DataSetColumn="MaViTri" />
              <Mapping SourceColumn="TenViTri" DataSetColumn="TenViTri" />
              <Mapping SourceColumn="TrangThai" DataSetColumn="TrangThai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NHANVIENTableAdapter" GeneratorDataComponentClassName="NHANVIENTableAdapter" Name="NHANVIEN" UserDataComponentName="NHANVIENTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.NHANVIEN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[NHANVIEN] WHERE (([MaNhanVien] = @Original_MaNhanVien) AND ([TenNhanVien] = @Original_TenNhanVien) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([MaQuanLy] = @Original_MaQuanLy) AND ([MaPhongBan] = @Original_MaPhongBan))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaQuanLy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaQuanLy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[NHANVIEN] ([MaNhanVien], [TenNhanVien], [NgaySinh], [Email], [MaQuanLy], [MaPhongBan]) VALUES (@MaNhanVien, @TenNhanVien, @NgaySinh, @Email, @MaQuanLy, @MaPhongBan);
SELECT MaNhanVien, TenNhanVien, NgaySinh, Email, MaQuanLy, MaPhongBan FROM NHANVIEN WHERE (MaNhanVien = @MaNhanVien)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaQuanLy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaQuanLy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaNhanVien, TenNhanVien, NgaySinh, Email, MaQuanLy, MaPhongBan FROM dbo.NHANVIEN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[NHANVIEN] SET [MaNhanVien] = @MaNhanVien, [TenNhanVien] = @TenNhanVien, [NgaySinh] = @NgaySinh, [Email] = @Email, [MaQuanLy] = @MaQuanLy, [MaPhongBan] = @MaPhongBan WHERE (([MaNhanVien] = @Original_MaNhanVien) AND ([TenNhanVien] = @Original_TenNhanVien) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([MaQuanLy] = @Original_MaQuanLy) AND ([MaPhongBan] = @Original_MaPhongBan));
SELECT MaNhanVien, TenNhanVien, NgaySinh, Email, MaQuanLy, MaPhongBan FROM NHANVIEN WHERE (MaNhanVien = @MaNhanVien)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaQuanLy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaQuanLy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaQuanLy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaQuanLy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaNhanVien" DataSetColumn="MaNhanVien" />
              <Mapping SourceColumn="TenNhanVien" DataSetColumn="TenNhanVien" />
              <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="MaQuanLy" DataSetColumn="MaQuanLy" />
              <Mapping SourceColumn="MaPhongBan" DataSetColumn="MaPhongBan" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NHANVIEN_KYNANGTableAdapter" GeneratorDataComponentClassName="NHANVIEN_KYNANGTableAdapter" Name="NHANVIEN_KYNANG" UserDataComponentName="NHANVIEN_KYNANGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.NHANVIEN_KYNANG" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[NHANVIEN_KYNANG] WHERE (([MaKyNang] = @Original_MaKyNang) AND ([MaNhanVien] = @Original_MaNhanVien) AND ((@IsNull_Khac = 1 AND [Khac] IS NULL) OR ([Khac] = @Original_Khac)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Khac" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Khac" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[NHANVIEN_KYNANG] ([MaKyNang], [MaNhanVien], [Khac]) VALUES (@MaKyNang, @MaNhanVien, @Khac);
SELECT MaKyNang, MaNhanVien, Khac FROM NHANVIEN_KYNANG WHERE (MaKyNang = @MaKyNang) AND (MaNhanVien = @MaNhanVien)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Khac" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaKyNang, MaNhanVien, Khac FROM dbo.NHANVIEN_KYNANG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[NHANVIEN_KYNANG] SET [MaKyNang] = @MaKyNang, [MaNhanVien] = @MaNhanVien, [Khac] = @Khac WHERE (([MaKyNang] = @Original_MaKyNang) AND ([MaNhanVien] = @Original_MaNhanVien) AND ((@IsNull_Khac = 1 AND [Khac] IS NULL) OR ([Khac] = @Original_Khac)));
SELECT MaKyNang, MaNhanVien, Khac FROM NHANVIEN_KYNANG WHERE (MaKyNang = @MaKyNang) AND (MaNhanVien = @MaNhanVien)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Khac" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKyNang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKyNang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Khac" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Khac" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Khac" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaKyNang" DataSetColumn="MaKyNang" />
              <Mapping SourceColumn="MaNhanVien" DataSetColumn="MaNhanVien" />
              <Mapping SourceColumn="Khac" DataSetColumn="Khac" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PHONGBANTableAdapter" GeneratorDataComponentClassName="PHONGBANTableAdapter" Name="PHONGBAN" UserDataComponentName="PHONGBANTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.PHONGBAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PHONGBAN] WHERE (([MaPhongBan] = @Original_MaPhongBan) AND ([TenPhongBan] = @Original_TenPhongBan) AND ([MaNhanVien] = @Original_MaNhanVien) AND ([MaChiNhanh] = @Original_MaChiNhanh))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PHONGBAN] ([MaPhongBan], [TenPhongBan], [MaNhanVien], [MaChiNhanh]) VALUES (@MaPhongBan, @TenPhongBan, @MaNhanVien, @MaChiNhanh);
SELECT MaPhongBan, TenPhongBan, MaNhanVien, MaChiNhanh FROM PHONGBAN WHERE (MaPhongBan = @MaPhongBan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaPhongBan, TenPhongBan, MaNhanVien, MaChiNhanh FROM dbo.PHONGBAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PHONGBAN] SET [MaPhongBan] = @MaPhongBan, [TenPhongBan] = @TenPhongBan, [MaNhanVien] = @MaNhanVien, [MaChiNhanh] = @MaChiNhanh WHERE (([MaPhongBan] = @Original_MaPhongBan) AND ([TenPhongBan] = @Original_TenPhongBan) AND ([MaNhanVien] = @Original_MaNhanVien) AND ([MaChiNhanh] = @Original_MaChiNhanh));
SELECT MaPhongBan, TenPhongBan, MaNhanVien, MaChiNhanh FROM PHONGBAN WHERE (MaPhongBan = @MaPhongBan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhongBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenPhongBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhongBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChiNhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChiNhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaPhongBan" DataSetColumn="MaPhongBan" />
              <Mapping SourceColumn="TenPhongBan" DataSetColumn="TenPhongBan" />
              <Mapping SourceColumn="MaNhanVien" DataSetColumn="MaNhanVien" />
              <Mapping SourceColumn="MaChiNhanh" DataSetColumn="MaChiNhanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="THAMGIADEANTableAdapter" GeneratorDataComponentClassName="THAMGIADEANTableAdapter" Name="THAMGIADEAN" UserDataComponentName="THAMGIADEANTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Ex_CTKT_05ConnectionString (Settings)" DbObjectName="Ex_CTKT_05.dbo.THAMGIADEAN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[THAMGIADEAN] WHERE (([MaDeAn] = @Original_MaDeAn) AND ([MaNhanVien] = @Original_MaNhanVien) AND ([MaViTri] = @Original_MaViTri) AND ((@IsNull_TrangThaiDA = 1 AND [TrangThaiDA] IS NULL) OR ([TrangThaiDA] = @Original_TrangThaiDA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThaiDA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TrangThaiDA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[THAMGIADEAN] ([MaDeAn], [MaNhanVien], [MaViTri], [TrangThaiDA]) VALUES (@MaDeAn, @MaNhanVien, @MaViTri, @TrangThaiDA);
SELECT MaDeAn, MaNhanVien, MaViTri, TrangThaiDA FROM THAMGIADEAN WHERE (MaDeAn = @MaDeAn) AND (MaNhanVien = @MaNhanVien) AND (MaViTri = @MaViTri)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TrangThaiDA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaDeAn, MaNhanVien, MaViTri, TrangThaiDA FROM dbo.THAMGIADEAN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[THAMGIADEAN] SET [MaDeAn] = @MaDeAn, [MaNhanVien] = @MaNhanVien, [MaViTri] = @MaViTri, [TrangThaiDA] = @TrangThaiDA WHERE (([MaDeAn] = @Original_MaDeAn) AND ([MaNhanVien] = @Original_MaNhanVien) AND ([MaViTri] = @Original_MaViTri) AND ((@IsNull_TrangThaiDA = 1 AND [TrangThaiDA] IS NULL) OR ([TrangThaiDA] = @Original_TrangThaiDA)));
SELECT MaDeAn, MaNhanVien, MaViTri, TrangThaiDA FROM THAMGIADEAN WHERE (MaDeAn = @MaDeAn) AND (MaNhanVien = @MaNhanVien) AND (MaViTri = @MaViTri)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TrangThaiDA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaDeAn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaDeAn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaNhanVien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaNhanVien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaViTri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaViTri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TrangThaiDA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TrangThaiDA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TrangThaiDA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaDeAn" DataSetColumn="MaDeAn" />
              <Mapping SourceColumn="MaNhanVien" DataSetColumn="MaNhanVien" />
              <Mapping SourceColumn="MaViTri" DataSetColumn="MaViTri" />
              <Mapping SourceColumn="TrangThaiDA" DataSetColumn="TrangThaiDA" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Ex_CTKT_05DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Ex_CTKT_05DataSet" msprop:Generator_UserDSName="Ex_CTKT_05DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CHINHANH" msprop:Generator_TableClassName="CHINHANHDataTable" msprop:Generator_TableVarName="tableCHINHANH" msprop:Generator_TablePropName="CHINHANH" msprop:Generator_RowDeletingName="CHINHANHRowDeleting" msprop:Generator_RowChangingName="CHINHANHRowChanging" msprop:Generator_RowEvHandlerName="CHINHANHRowChangeEventHandler" msprop:Generator_RowDeletedName="CHINHANHRowDeleted" msprop:Generator_UserTableName="CHINHANH" msprop:Generator_RowChangedName="CHINHANHRowChanged" msprop:Generator_RowEvArgName="CHINHANHRowChangeEvent" msprop:Generator_RowClassName="CHINHANHRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaChiNhanh" msprop:Generator_ColumnVarNameInTable="columnMaChiNhanh" msprop:Generator_ColumnPropNameInRow="MaChiNhanh" msprop:Generator_ColumnPropNameInTable="MaChiNhanhColumn" msprop:Generator_UserColumnName="MaChiNhanh">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenChiNhanh" msprop:Generator_ColumnVarNameInTable="columnTenChiNhanh" msprop:Generator_ColumnPropNameInRow="TenChiNhanh" msprop:Generator_ColumnPropNameInTable="TenChiNhanhColumn" msprop:Generator_UserColumnName="TenChiNhanh">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DienThoai" msprop:Generator_ColumnVarNameInTable="columnDienThoai" msprop:Generator_ColumnPropNameInRow="DienThoai" msprop:Generator_ColumnPropNameInTable="DienThoaiColumn" msprop:Generator_UserColumnName="DienThoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaCongTy" msprop:Generator_ColumnVarNameInTable="columnMaCongTy" msprop:Generator_ColumnPropNameInRow="MaCongTy" msprop:Generator_ColumnPropNameInTable="MaCongTyColumn" msprop:Generator_UserColumnName="MaCongTy">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CONGTY" msprop:Generator_TableClassName="CONGTYDataTable" msprop:Generator_TableVarName="tableCONGTY" msprop:Generator_TablePropName="CONGTY" msprop:Generator_RowDeletingName="CONGTYRowDeleting" msprop:Generator_RowChangingName="CONGTYRowChanging" msprop:Generator_RowEvHandlerName="CONGTYRowChangeEventHandler" msprop:Generator_RowDeletedName="CONGTYRowDeleted" msprop:Generator_UserTableName="CONGTY" msprop:Generator_RowChangedName="CONGTYRowChanged" msprop:Generator_RowEvArgName="CONGTYRowChangeEvent" msprop:Generator_RowClassName="CONGTYRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaCongTy" msprop:Generator_ColumnVarNameInTable="columnMaCongTy" msprop:Generator_ColumnPropNameInRow="MaCongTy" msprop:Generator_ColumnPropNameInTable="MaCongTyColumn" msprop:Generator_UserColumnName="MaCongTy">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenCongTy" msprop:Generator_ColumnVarNameInTable="columnTenCongTy" msprop:Generator_ColumnPropNameInRow="TenCongTy" msprop:Generator_ColumnPropNameInTable="TenCongTyColumn" msprop:Generator_UserColumnName="TenCongTy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DienThoai" msprop:Generator_ColumnVarNameInTable="columnDienThoai" msprop:Generator_ColumnPropNameInRow="DienThoai" msprop:Generator_ColumnPropNameInTable="DienThoaiColumn" msprop:Generator_UserColumnName="DienThoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Website" msprop:Generator_ColumnVarNameInTable="columnWebsite" msprop:Generator_ColumnPropNameInRow="Website" msprop:Generator_ColumnPropNameInTable="WebsiteColumn" msprop:Generator_UserColumnName="Website" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DEAN" msprop:Generator_TableClassName="DEANDataTable" msprop:Generator_TableVarName="tableDEAN" msprop:Generator_TablePropName="DEAN" msprop:Generator_RowDeletingName="DEANRowDeleting" msprop:Generator_RowChangingName="DEANRowChanging" msprop:Generator_RowEvHandlerName="DEANRowChangeEventHandler" msprop:Generator_RowDeletedName="DEANRowDeleted" msprop:Generator_UserTableName="DEAN" msprop:Generator_RowChangedName="DEANRowChanged" msprop:Generator_RowEvArgName="DEANRowChangeEvent" msprop:Generator_RowClassName="DEANRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaDeAn" msprop:Generator_ColumnVarNameInTable="columnMaDeAn" msprop:Generator_ColumnPropNameInRow="MaDeAn" msprop:Generator_ColumnPropNameInTable="MaDeAnColumn" msprop:Generator_UserColumnName="MaDeAn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenDeAn" msprop:Generator_ColumnVarNameInTable="columnTenDeAn" msprop:Generator_ColumnPropNameInRow="TenDeAn" msprop:Generator_ColumnPropNameInTable="TenDeAnColumn" msprop:Generator_UserColumnName="TenDeAn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMKYNANG" msprop:Generator_TableClassName="DMKYNANGDataTable" msprop:Generator_TableVarName="tableDMKYNANG" msprop:Generator_TablePropName="DMKYNANG" msprop:Generator_RowDeletingName="DMKYNANGRowDeleting" msprop:Generator_RowChangingName="DMKYNANGRowChanging" msprop:Generator_RowEvHandlerName="DMKYNANGRowChangeEventHandler" msprop:Generator_RowDeletedName="DMKYNANGRowDeleted" msprop:Generator_UserTableName="DMKYNANG" msprop:Generator_RowChangedName="DMKYNANGRowChanged" msprop:Generator_RowEvArgName="DMKYNANGRowChangeEvent" msprop:Generator_RowClassName="DMKYNANGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaKyNang" msprop:Generator_ColumnVarNameInTable="columnMaKyNang" msprop:Generator_ColumnPropNameInRow="MaKyNang" msprop:Generator_ColumnPropNameInTable="MaKyNangColumn" msprop:Generator_UserColumnName="MaKyNang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenKyNang" msprop:Generator_ColumnVarNameInTable="columnTenKyNang" msprop:Generator_ColumnPropNameInRow="TenKyNang" msprop:Generator_ColumnPropNameInTable="TenKyNangColumn" msprop:Generator_UserColumnName="TenKyNang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" msprop:Generator_UserColumnName="GhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMVITRI" msprop:Generator_TableClassName="DMVITRIDataTable" msprop:Generator_TableVarName="tableDMVITRI" msprop:Generator_TablePropName="DMVITRI" msprop:Generator_RowDeletingName="DMVITRIRowDeleting" msprop:Generator_RowChangingName="DMVITRIRowChanging" msprop:Generator_RowEvHandlerName="DMVITRIRowChangeEventHandler" msprop:Generator_RowDeletedName="DMVITRIRowDeleted" msprop:Generator_UserTableName="DMVITRI" msprop:Generator_RowChangedName="DMVITRIRowChanged" msprop:Generator_RowEvArgName="DMVITRIRowChangeEvent" msprop:Generator_RowClassName="DMVITRIRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaViTri" msprop:Generator_ColumnVarNameInTable="columnMaViTri" msprop:Generator_ColumnPropNameInRow="MaViTri" msprop:Generator_ColumnPropNameInTable="MaViTriColumn" msprop:Generator_UserColumnName="MaViTri">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenViTri" msprop:Generator_ColumnVarNameInTable="columnTenViTri" msprop:Generator_ColumnPropNameInRow="TenViTri" msprop:Generator_ColumnPropNameInTable="TenViTriColumn" msprop:Generator_UserColumnName="TenViTri">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrangThai" msprop:Generator_ColumnVarNameInTable="columnTrangThai" msprop:Generator_ColumnPropNameInRow="TrangThai" msprop:Generator_ColumnPropNameInTable="TrangThaiColumn" msprop:Generator_UserColumnName="TrangThai" type="xs:unsignedByte" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NHANVIEN" msprop:Generator_TableClassName="NHANVIENDataTable" msprop:Generator_TableVarName="tableNHANVIEN" msprop:Generator_TablePropName="NHANVIEN" msprop:Generator_RowDeletingName="NHANVIENRowDeleting" msprop:Generator_RowChangingName="NHANVIENRowChanging" msprop:Generator_RowEvHandlerName="NHANVIENRowChangeEventHandler" msprop:Generator_RowDeletedName="NHANVIENRowDeleted" msprop:Generator_UserTableName="NHANVIEN" msprop:Generator_RowChangedName="NHANVIENRowChanged" msprop:Generator_RowEvArgName="NHANVIENRowChangeEvent" msprop:Generator_RowClassName="NHANVIENRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaNhanVien" msprop:Generator_ColumnVarNameInTable="columnMaNhanVien" msprop:Generator_ColumnPropNameInRow="MaNhanVien" msprop:Generator_ColumnPropNameInTable="MaNhanVienColumn" msprop:Generator_UserColumnName="MaNhanVien">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenNhanVien" msprop:Generator_ColumnVarNameInTable="columnTenNhanVien" msprop:Generator_ColumnPropNameInRow="TenNhanVien" msprop:Generator_ColumnPropNameInTable="TenNhanVienColumn" msprop:Generator_UserColumnName="TenNhanVien">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" msprop:Generator_UserColumnName="NgaySinh" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaQuanLy" msprop:Generator_ColumnVarNameInTable="columnMaQuanLy" msprop:Generator_ColumnPropNameInRow="MaQuanLy" msprop:Generator_ColumnPropNameInTable="MaQuanLyColumn" msprop:Generator_UserColumnName="MaQuanLy">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaPhongBan" msprop:Generator_ColumnVarNameInTable="columnMaPhongBan" msprop:Generator_ColumnPropNameInRow="MaPhongBan" msprop:Generator_ColumnPropNameInTable="MaPhongBanColumn" msprop:Generator_UserColumnName="MaPhongBan">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NHANVIEN_KYNANG" msprop:Generator_TableClassName="NHANVIEN_KYNANGDataTable" msprop:Generator_TableVarName="tableNHANVIEN_KYNANG" msprop:Generator_TablePropName="NHANVIEN_KYNANG" msprop:Generator_RowDeletingName="NHANVIEN_KYNANGRowDeleting" msprop:Generator_RowChangingName="NHANVIEN_KYNANGRowChanging" msprop:Generator_RowEvHandlerName="NHANVIEN_KYNANGRowChangeEventHandler" msprop:Generator_RowDeletedName="NHANVIEN_KYNANGRowDeleted" msprop:Generator_UserTableName="NHANVIEN_KYNANG" msprop:Generator_RowChangedName="NHANVIEN_KYNANGRowChanged" msprop:Generator_RowEvArgName="NHANVIEN_KYNANGRowChangeEvent" msprop:Generator_RowClassName="NHANVIEN_KYNANGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaKyNang" msprop:Generator_ColumnVarNameInTable="columnMaKyNang" msprop:Generator_ColumnPropNameInRow="MaKyNang" msprop:Generator_ColumnPropNameInTable="MaKyNangColumn" msprop:Generator_UserColumnName="MaKyNang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaNhanVien" msprop:Generator_ColumnVarNameInTable="columnMaNhanVien" msprop:Generator_ColumnPropNameInRow="MaNhanVien" msprop:Generator_ColumnPropNameInTable="MaNhanVienColumn" msprop:Generator_UserColumnName="MaNhanVien">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Khac" msprop:Generator_ColumnVarNameInTable="columnKhac" msprop:Generator_ColumnPropNameInRow="Khac" msprop:Generator_ColumnPropNameInTable="KhacColumn" msprop:Generator_UserColumnName="Khac" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PHONGBAN" msprop:Generator_TableClassName="PHONGBANDataTable" msprop:Generator_TableVarName="tablePHONGBAN" msprop:Generator_TablePropName="PHONGBAN" msprop:Generator_RowDeletingName="PHONGBANRowDeleting" msprop:Generator_RowChangingName="PHONGBANRowChanging" msprop:Generator_RowEvHandlerName="PHONGBANRowChangeEventHandler" msprop:Generator_RowDeletedName="PHONGBANRowDeleted" msprop:Generator_UserTableName="PHONGBAN" msprop:Generator_RowChangedName="PHONGBANRowChanged" msprop:Generator_RowEvArgName="PHONGBANRowChangeEvent" msprop:Generator_RowClassName="PHONGBANRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaPhongBan" msprop:Generator_ColumnVarNameInTable="columnMaPhongBan" msprop:Generator_ColumnPropNameInRow="MaPhongBan" msprop:Generator_ColumnPropNameInTable="MaPhongBanColumn" msprop:Generator_UserColumnName="MaPhongBan">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenPhongBan" msprop:Generator_ColumnVarNameInTable="columnTenPhongBan" msprop:Generator_ColumnPropNameInRow="TenPhongBan" msprop:Generator_ColumnPropNameInTable="TenPhongBanColumn" msprop:Generator_UserColumnName="TenPhongBan">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaNhanVien" msprop:Generator_ColumnVarNameInTable="columnMaNhanVien" msprop:Generator_ColumnPropNameInRow="MaNhanVien" msprop:Generator_ColumnPropNameInTable="MaNhanVienColumn" msprop:Generator_UserColumnName="MaNhanVien">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaChiNhanh" msprop:Generator_ColumnVarNameInTable="columnMaChiNhanh" msprop:Generator_ColumnPropNameInRow="MaChiNhanh" msprop:Generator_ColumnPropNameInTable="MaChiNhanhColumn" msprop:Generator_UserColumnName="MaChiNhanh">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="THAMGIADEAN" msprop:Generator_TableClassName="THAMGIADEANDataTable" msprop:Generator_TableVarName="tableTHAMGIADEAN" msprop:Generator_TablePropName="THAMGIADEAN" msprop:Generator_RowDeletingName="THAMGIADEANRowDeleting" msprop:Generator_RowChangingName="THAMGIADEANRowChanging" msprop:Generator_RowEvHandlerName="THAMGIADEANRowChangeEventHandler" msprop:Generator_RowDeletedName="THAMGIADEANRowDeleted" msprop:Generator_UserTableName="THAMGIADEAN" msprop:Generator_RowChangedName="THAMGIADEANRowChanged" msprop:Generator_RowEvArgName="THAMGIADEANRowChangeEvent" msprop:Generator_RowClassName="THAMGIADEANRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaDeAn" msprop:Generator_ColumnVarNameInTable="columnMaDeAn" msprop:Generator_ColumnPropNameInRow="MaDeAn" msprop:Generator_ColumnPropNameInTable="MaDeAnColumn" msprop:Generator_UserColumnName="MaDeAn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaNhanVien" msprop:Generator_ColumnVarNameInTable="columnMaNhanVien" msprop:Generator_ColumnPropNameInRow="MaNhanVien" msprop:Generator_ColumnPropNameInTable="MaNhanVienColumn" msprop:Generator_UserColumnName="MaNhanVien">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaViTri" msprop:Generator_ColumnVarNameInTable="columnMaViTri" msprop:Generator_ColumnPropNameInRow="MaViTri" msprop:Generator_ColumnPropNameInTable="MaViTriColumn" msprop:Generator_UserColumnName="MaViTri">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrangThaiDA" msprop:Generator_ColumnVarNameInTable="columnTrangThaiDA" msprop:Generator_ColumnPropNameInRow="TrangThaiDA" msprop:Generator_ColumnPropNameInTable="TrangThaiDAColumn" msprop:Generator_UserColumnName="TrangThaiDA" type="xs:unsignedByte" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CHINHANH" />
      <xs:field xpath="mstns:MaChiNhanh" />
    </xs:unique>
    <xs:unique name="CONGTY_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CONGTY" />
      <xs:field xpath="mstns:MaCongTy" />
    </xs:unique>
    <xs:unique name="DEAN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DEAN" />
      <xs:field xpath="mstns:MaDeAn" />
    </xs:unique>
    <xs:unique name="DMKYNANG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMKYNANG" />
      <xs:field xpath="mstns:MaKyNang" />
    </xs:unique>
    <xs:unique name="DMVITRI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMVITRI" />
      <xs:field xpath="mstns:MaViTri" />
    </xs:unique>
    <xs:unique name="NHANVIEN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NHANVIEN" />
      <xs:field xpath="mstns:MaNhanVien" />
    </xs:unique>
    <xs:unique name="NHANVIEN_KYNANG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NHANVIEN_KYNANG" />
      <xs:field xpath="mstns:MaKyNang" />
      <xs:field xpath="mstns:MaNhanVien" />
    </xs:unique>
    <xs:unique name="PHONGBAN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PHONGBAN" />
      <xs:field xpath="mstns:MaPhongBan" />
    </xs:unique>
    <xs:unique name="THAMGIADEAN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:THAMGIADEAN" />
      <xs:field xpath="mstns:MaDeAn" />
      <xs:field xpath="mstns:MaNhanVien" />
      <xs:field xpath="mstns:MaViTri" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_CHINHANH_CONGTY" msdata:parent="CONGTY" msdata:child="CHINHANH" msdata:parentkey="MaCongTy" msdata:childkey="MaCongTy" msprop:Generator_UserChildTable="CHINHANH" msprop:Generator_ChildPropName="GetCHINHANHRows" msprop:Generator_UserRelationName="FK_CHINHANH_CONGTY" msprop:Generator_RelationVarName="relationFK_CHINHANH_CONGTY" msprop:Generator_UserParentTable="CONGTY" msprop:Generator_ParentPropName="CONGTYRow" />
      <msdata:Relationship name="FK_NHANVIEN_NHANVIEN" msdata:parent="NHANVIEN" msdata:child="NHANVIEN" msdata:parentkey="MaNhanVien" msdata:childkey="MaQuanLy" msprop:Generator_UserChildTable="NHANVIEN" msprop:Generator_ChildPropName="GetNHANVIENRows" msprop:Generator_UserRelationName="FK_NHANVIEN_NHANVIEN" msprop:Generator_RelationVarName="relationFK_NHANVIEN_NHANVIEN" msprop:Generator_UserParentTable="NHANVIEN" msprop:Generator_ParentPropName="NHANVIENRowParent" />
      <msdata:Relationship name="FK_NHANVIEN_PHONGBAN" msdata:parent="PHONGBAN" msdata:child="NHANVIEN" msdata:parentkey="MaPhongBan" msdata:childkey="MaPhongBan" msprop:Generator_UserChildTable="NHANVIEN" msprop:Generator_ChildPropName="GetNHANVIENRows" msprop:Generator_UserRelationName="FK_NHANVIEN_PHONGBAN" msprop:Generator_RelationVarName="relationFK_NHANVIEN_PHONGBAN" msprop:Generator_UserParentTable="PHONGBAN" msprop:Generator_ParentPropName="PHONGBANRow" />
      <msdata:Relationship name="FK_DMKYNANG_NHANVIEN_KYNANG" msdata:parent="DMKYNANG" msdata:child="NHANVIEN_KYNANG" msdata:parentkey="MaKyNang" msdata:childkey="MaKyNang" msprop:Generator_UserChildTable="NHANVIEN_KYNANG" msprop:Generator_ChildPropName="GetNHANVIEN_KYNANGRows" msprop:Generator_UserRelationName="FK_DMKYNANG_NHANVIEN_KYNANG" msprop:Generator_ParentPropName="DMKYNANGRow" msprop:Generator_RelationVarName="relationFK_DMKYNANG_NHANVIEN_KYNANG" msprop:Generator_UserParentTable="DMKYNANG" />
      <msdata:Relationship name="FK_NHANVIEN_NHANVIEN_KYNANG" msdata:parent="NHANVIEN" msdata:child="NHANVIEN_KYNANG" msdata:parentkey="MaNhanVien" msdata:childkey="MaNhanVien" msprop:Generator_UserChildTable="NHANVIEN_KYNANG" msprop:Generator_ChildPropName="GetNHANVIEN_KYNANGRows" msprop:Generator_UserRelationName="FK_NHANVIEN_NHANVIEN_KYNANG" msprop:Generator_ParentPropName="NHANVIENRow" msprop:Generator_RelationVarName="relationFK_NHANVIEN_NHANVIEN_KYNANG" msprop:Generator_UserParentTable="NHANVIEN" />
      <msdata:Relationship name="FK_PHONGBAN_CHINHANH" msdata:parent="CHINHANH" msdata:child="PHONGBAN" msdata:parentkey="MaChiNhanh" msdata:childkey="MaChiNhanh" msprop:Generator_UserChildTable="PHONGBAN" msprop:Generator_ChildPropName="GetPHONGBANRows" msprop:Generator_UserRelationName="FK_PHONGBAN_CHINHANH" msprop:Generator_ParentPropName="CHINHANHRow" msprop:Generator_RelationVarName="relationFK_PHONGBAN_CHINHANH" msprop:Generator_UserParentTable="CHINHANH" />
      <msdata:Relationship name="FK_PHONGBAN_NHANVIEN" msdata:parent="NHANVIEN" msdata:child="PHONGBAN" msdata:parentkey="MaNhanVien" msdata:childkey="MaNhanVien" msprop:Generator_UserChildTable="PHONGBAN" msprop:Generator_ChildPropName="GetPHONGBANRows" msprop:Generator_UserRelationName="FK_PHONGBAN_NHANVIEN" msprop:Generator_ParentPropName="NHANVIENRow" msprop:Generator_RelationVarName="relationFK_PHONGBAN_NHANVIEN" msprop:Generator_UserParentTable="NHANVIEN" />
      <msdata:Relationship name="FK_THAMGIADEAN_DEAN" msdata:parent="DEAN" msdata:child="THAMGIADEAN" msdata:parentkey="MaDeAn" msdata:childkey="MaDeAn" msprop:Generator_UserChildTable="THAMGIADEAN" msprop:Generator_ChildPropName="GetTHAMGIADEANRows" msprop:Generator_UserRelationName="FK_THAMGIADEAN_DEAN" msprop:Generator_ParentPropName="DEANRow" msprop:Generator_RelationVarName="relationFK_THAMGIADEAN_DEAN" msprop:Generator_UserParentTable="DEAN" />
      <msdata:Relationship name="FK_THAMGIADEAN_DMVITRI" msdata:parent="DMVITRI" msdata:child="THAMGIADEAN" msdata:parentkey="MaViTri" msdata:childkey="MaViTri" msprop:Generator_UserChildTable="THAMGIADEAN" msprop:Generator_ChildPropName="GetTHAMGIADEANRows" msprop:Generator_UserRelationName="FK_THAMGIADEAN_DMVITRI" msprop:Generator_ParentPropName="DMVITRIRow" msprop:Generator_RelationVarName="relationFK_THAMGIADEAN_DMVITRI" msprop:Generator_UserParentTable="DMVITRI" />
      <msdata:Relationship name="FK_THAMGIADEAN_NHANVIEN" msdata:parent="NHANVIEN" msdata:child="THAMGIADEAN" msdata:parentkey="MaNhanVien" msdata:childkey="MaNhanVien" msprop:Generator_UserChildTable="THAMGIADEAN" msprop:Generator_ChildPropName="GetTHAMGIADEANRows" msprop:Generator_UserRelationName="FK_THAMGIADEAN_NHANVIEN" msprop:Generator_ParentPropName="NHANVIENRow" msprop:Generator_RelationVarName="relationFK_THAMGIADEAN_NHANVIEN" msprop:Generator_UserParentTable="NHANVIEN" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>